{
  "properties" : { },
  "id" : "4b06f2018c094504b3864a0c45a18a20",
  "script" : null,
  "groupId" : "e23168f26d1d48c3be60461b66119096",
  "name" : "查找代理配置分页",
  "createTime" : 1727071160185,
  "updateTime" : 1725004221392,
  "lock" : "1",
  "createBy" : "ndmp",
  "updateBy" : "ndmp",
  "path" : "/page",
  "method" : "POST",
  "parameters" : [ ],
  "options" : [ ],
  "requestBody" : " {\r\n     \"current\": 1,\r\n     \"size\": 10\r\n }",
  "headers" : [ ],
  "paths" : [ ],
  "responseBody" : "{\n    \"status\": 200,\n    \"message\": \"success\",\n    \"data\": {\n        \"total\": 2,\n        \"current\": 1,\n        \"size\": 10,\n        \"records\": [\n            {\n                \"ip\": \"192.168.2.56\",\n                \"port\": \"8848\",\n                \"region\": \"2\",\n                \"descrip\": \"8848\",\n                \"id\": \"1829419067128287232\",\n                \"rowId\": \"1\"\n            },\n            {\n                \"ip\": \"192.168.1.64\",\n                \"port\": \"8846\",\n                \"region\": \"3\",\n                \"descrip\": \"8846\",\n                \"id\": \"1829419772123680768\",\n                \"rowId\": \"2\"\n            }\n        ]\n    }\n}",
  "description" : "",
  "requestBodyDefinition" : {
    "name" : "",
    "value" : { },
    "description" : "",
    "required" : false,
    "dataType" : "String",
    "type" : "",
    "defaultValue" : "",
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ ]
  },
  "responseBodyDefinition" : {
    "name" : "",
    "value" : "",
    "description" : "",
    "required" : false,
    "dataType" : "String",
    "type" : null,
    "defaultValue" : "",
    "validateType" : "",
    "error" : "",
    "expression" : "",
    "children" : [ {
      "name" : "status",
      "value" : "200",
      "description" : "",
      "required" : false,
      "dataType" : "Integer",
      "type" : null,
      "defaultValue" : null,
      "validateType" : "",
      "error" : "",
      "expression" : "",
      "children" : [ ]
    }, {
      "name" : "message",
      "value" : "success",
      "description" : "",
      "required" : false,
      "dataType" : "String",
      "type" : null,
      "defaultValue" : null,
      "validateType" : "",
      "error" : "",
      "expression" : "",
      "children" : [ ]
    }, {
      "name" : "data",
      "value" : "",
      "description" : "",
      "required" : false,
      "dataType" : "Object",
      "type" : null,
      "defaultValue" : null,
      "validateType" : "",
      "error" : "",
      "expression" : "",
      "children" : [ {
        "name" : "total",
        "value" : "1",
        "description" : "",
        "required" : false,
        "dataType" : "Integer",
        "type" : null,
        "defaultValue" : null,
        "validateType" : "",
        "error" : "",
        "expression" : "",
        "children" : [ ]
      }, {
        "name" : "current",
        "value" : "1",
        "description" : "",
        "required" : false,
        "dataType" : "Integer",
        "type" : null,
        "defaultValue" : null,
        "validateType" : "",
        "error" : "",
        "expression" : "",
        "children" : [ ]
      }, {
        "name" : "size",
        "value" : "10",
        "description" : "",
        "required" : false,
        "dataType" : "Integer",
        "type" : null,
        "defaultValue" : null,
        "validateType" : "",
        "error" : "",
        "expression" : "",
        "children" : [ ]
      }, {
        "name" : "records",
        "value" : "",
        "description" : "",
        "required" : false,
        "dataType" : "Array",
        "type" : null,
        "defaultValue" : null,
        "validateType" : "",
        "error" : "",
        "expression" : "",
        "children" : [ ]
      } ]
    } ]
  }
}
================================
var sql ="""
  select * from ndmp_remote_region
            <where>
                <if test="body.ip != null and body.ip != ''">
                    ip like concat( #{body.ip}, '%')
                </if>
                <if test="body.port != null and body.port != ''">
                    port like concat( #{body.port}, '%')
                </if>
                <if test="body.region != null and body.region != ''">
                    region like concat( #{body.region}, '%')
                </if>
            </where>
        """
return db.page(sql,body.size,body.current-1)